# coding: utf-8

from application import db

class ShopDetail(db.Model):
    __tablename__ = 'shopDetail'

    id = db.Column(db.Integer, primary_key=True)
    uid = db.Column(db.Integer, nullable=False, unique=True)
    shop_id = db.Column(db.Integer, nullable=False)
    title = db.Column(db.String(255))
    nickname = db.Column(db.String(100))
    phone = db.Column(db.String(20))
    city = db.Column(db.String(100))
    url = db.Column(db.String(100))
    status = db.Column(db.Integer, server_default=db.FetchedValue())
    addtime = db.Column(db.DateTime, server_default=db.FetchedValue())
